{# What Rows and Query share: the note saying why the app's data is hidden
   (``exposure.refusal``), and rows read like Logs (``rows_scroller``): one
   line each, cut at the edge like a log line, a click opening one, a
   column holding a secret shown as hidden. ``found`` is a page
   (db_rows.Rows) or an answer (db_query.Answer); ``body`` the tbody's id,
   for Top and Bottom; ``key`` the column the pages run on; ``links``, a
   row's keys (overseer_database_browser.row_links), opening under it with it,
   each opening that table (``#database-table``); ``sorts``, the columns
   the server orders the whole table by (overseer_database_browser.rows), each
   header a link, every other header sorting the rows shown (rows.js),
   which ``export_menu`` exports. #}
{% from "components/macros/icons.html" import icon %}
{% from "components/macros/layout.html" import dropdown, menu_heading, menu_item %}
{% from "pages/overseer/_macros.html" import opens_rows %}

{% macro rows_off_note(reason) %}
<p data-rows-off class="text-sm text-aegis-muted">A table's rows are the app's data: {{ reason }}</p>
{%- endmacro %}

{% macro export_menu(body, name) %}
{% set label %}{{ icon("arrow-up-tray", "w-3.5 h-3.5") }}Export{% endset %}
{% call dropdown(label) %}
{% set formats = {"csv": ("CSV", "document-text"), "json": ("JSON", "code-bracket"), "tsv": ("For a sheet", "table-cells"), "markdown": ("Markdown table", "hashtag")} %}
{% for to, heading, glyph, picks in (("file", "Download", "arrow-down-tray", ("csv", "json")), ("copy", "Copy", "copy", ("tsv", "csv", "json", "markdown"))) %}
{{ menu_heading(heading, glyph) }}
{% for format in picks %}
{% set attrs %}data-export="{{ format }}" data-export-to="{{ to }}" data-export-rows="#{{ body }}" data-export-name="{{ name }}"{% endset %}
{% set item %}<span class="inline-flex items-center gap-2">{{ icon(formats[format][1], "w-3.5 h-3.5 text-aegis-muted") }}{{ formats[format][0] }}</span>{% endset %}
{{ menu_item(item, attrs) }}
{% endfor %}
{% endfor %}
{% endcall %}
{%- endmacro %}

{% macro rows_table(found, body, key=None, empty="No rows.", links=None, sorts=None) %}
{% set arrows %}{{ icon("arrow-up", "rows-sort-up w-3 h-3", 2) }}{{ icon("arrow-down", "rows-sort-down w-3 h-3", 2) }}{% endset %}
<table data-rows class="w-full text-xs font-mono">
  <thead class="sticky top-0 bg-aegis-bg">
    <tr>{% for column in found.columns %}{% set order = sorts.get(column) if sorts else none %}<th data-column="{{ column }}"{% if order and order.sort %} aria-sort="{{ order.sort }}"{% endif %} class="px-3 py-1.5 text-left font-normal text-aegis-muted whitespace-nowrap">{% if order %}<a href="{{ order.url }}" {{ hx_replace(order.url, "#database-rows") }} class="rows-sort">{{ column }}{{ arrows }}</a>{% else %}<button type="button" data-sort-rows class="rows-sort">{{ column }}{{ arrows }}</button>{% endif %}{% if column == key %}<span class="ml-1 text-aegis-teal" title="The key the pages run on">⌗</span>{% endif %}</th>{% endfor %}</tr>
  </thead>
  <tbody id="{{ body }}" {{ opens_rows() }}>
    {% for row in found.rows %}
    <tr class="log-row">
      {% for cell in row %}{% set column = found.columns[loop.index0] %}<td class="px-3 py-1 max-w-xs {{ 'text-aegis-muted' if column in found.masked else 'text-aegis-text' }}"{% if column in found.masked %} title="Hidden: it holds a secret"{% endif %}><div class="log-line">{{ cell }}</div></td>{% endfor %}
    </tr>
    {% if links and links[loop.index0] %}
    <tr data-links><td colspan="{{ found.columns|length }}" class="px-3 pb-2"><div class="flex flex-wrap gap-x-4 gap-y-1">{% for link in links[loop.index0] %}<a href="{{ link.url }}" {{ hx_replace(link.url, "#database-table") }} class="text-aegis-teal hover:underline">{{ link.label }}</a>{% endfor %}</div></td></tr>
    {% endif %}
    {% endfor %}
  </tbody>
</table>
{% if not found.rows %}<p class="px-3 py-4 text-sm text-aegis-muted">{{ empty }}</p>{% endif %}
{%- endmacro %}